<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="../styles/style.css" rel="stylesheet" type="text/css">
<title>Untitled Document</title>
<style type="text/css">
<!--
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}
.style3 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; }
.style4 {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-weight: bold;
	font-size: 11px;
}
-->
</style></head>

<body> 
   <div align="center">
<div align="center">
       <?
require("../db.php"); 
 if(isset($_GET['controluser']))
 { 
 
 
$querydetalle =" SELECT     dbo.tbl_UsuariosWeb.st_Email, dbo.tbl_UsuariosWeb.st_Tarjeta, dbo.tbl_UsuariosWeb.st_Nombre + ' ' + dbo.tbl_UsuariosWeb.st_ApellidoPaterno + ' ' + dbo.tbl_UsuariosWeb.st_ApellidoMaterno as st_NombreCompleto, dbo.app_NotesUsuariosWeb.st_Asunto, dbo.app_NotesUsuariosWeb.st_Notes, 
                      dbo.app_NotesUsuariosWeb.dt_FechaRegistro, dbo.app_NotesUsuariosWeb.id_NotesUsuarioweb, dbo.tbl_UsuariosWeb.id_UsuarioWeb
FROM         dbo.app_NotesUsuariosWeb INNER JOIN
                      dbo.tbl_UsuariosWeb ON dbo.app_NotesUsuariosWeb.id_UsuarioWeb = dbo.tbl_UsuariosWeb.id_UsuarioWeb
WHERE     (dbo.app_NotesUsuariosWeb.id_NotesUsuarioweb = ".$_GET['controluser'].")";

$rquerydetalle= mssql_query($querydetalle);
$rowWeb=mssql_fetch_object($rquerydetalle);

 
 ?>
 
 
  <table width="80%" border="0" cellspacing="1" cellpadding="5" class="mainTableBG">
         <tr >
           <td colspan="2"><strong class="mainTableTitle">Notas</strong></td>
         </tr>
         <tr class="conceptCellBG">
           <td >Tarjeta:</td>
           <td class="answerCellBG"><?=$rowWeb->Tarjeta ?>xc</td>
         </tr>
         <tr class="conceptCellBG">
           <td>Nombre:</td>
           <td class="answerCellBG"><?=$rowWeb->st_NombreCompleto ?></td>
         </tr>
         <tr class="conceptCellBG">
           <td >Asunto:</td>
           <td class="answerCellBG"><?=$rowWeb->st_Asunto ?></td>
         </tr>

      
         <tr class="conceptCellBG">
           <td colspan="2">Nota:</td>
         </tr>
         <tr class="conceptCellBG">
           <td colspan="2" class="answerCellBG"><br />
             [
             <?=date('d/m/Y H:i:s',strtotime($rowWeb->dt_FechaRegistro)) ?>
             ]:
             <?=$rowWeb->st_Notes ?></td>
         </tr>
         <tr class="answerCellBG">
           <td colspan="2"><table border="0" cellpadding="5" cellspacing="1" class="mainTableBG">
             <tr class="answerCellBG">
                  <td><img src="../images/icArrowGo.gif" height="13" width="13" alt=""></td>
                  <td><a href="javascript:history.back();" target="content">Regresar</a></td>
                 </tr>
           </table></td>
         </tr>
       </table>
       <?
 exit();
 }?>
       <span class="style4">NOTAS<BR /><BR /></span></div>
     <div align="center" class="style1">
</div>
   <div align="center">

  <table width="50%" border="0" cellpadding="0" cellspacing="0" >
    <tr>
      <td bgcolor="#CCCCCC"><div align="center" class="style3">
        <div align="center">Asunto</div>
      </div></td>
      <td bgcolor="#CCCCCC"><div align="center" class="style3">
        <div align="center">Fecha</div>
      </div></td>
    </tr>
 
 
<?

$qry="SELECT     *
FROM       app_NotesUsuariosWeb
where  id_UsuarioWeb =  ".$_GET['iduser']."
 order by dt_FechaRegistro desc ";
$rqry=mssql_query($qry);
while($row=mssql_fetch_array($rqry))
 {
?>
    <tr>
      <td><div align="center"><span class="style3"><a href=all_Global_Notes.php?controluser=<?=$row['id_NotesUsuarioweb']?>><?=$row['st_Asunto']?></a></span></div></td>
      <td><div align="center"><span class="style3"><?=$row['dt_FechaRegistro']?></span></div></td>
    </tr><? }?>
  </table>
</div>
</body>
</html>
